﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="search.aspx.vb" Inherits="SwissBiking.search" %>
<asp:Content ID="Content1" ContentPlaceHolderID="FeaturedContent" runat="server">
</asp:Content>


<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">

        Search Results:
    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" CellPadding="4" ForeColor="#333333" GridLines="None">
        <AlternatingRowStyle BackColor="White" />
        <Columns>
            <asp:BoundField DataField="title" HeaderText="title" SortExpression="title" />
          
            <asp:BoundField DataField="description" HeaderText="Description" SortExpression="description" />
            <asp:BoundField DataField="difficulty" HeaderText="Difficulty" SortExpression="difficulty" />
            <asp:BoundField DataField="type" HeaderText="Route Type" SortExpression="type" />
            <asp:BoundField DataField="length" HeaderText="Length(KM)" SortExpression="length" />
            <asp:HyperLinkField Text="View Details" DataNavigateUrlFormatString="~/routedetails.aspx?q={0}" DataNavigateUrlFields="id" />
        </Columns>
        <EditRowStyle BackColor="#2461BF" />
        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
        <RowStyle BackColor="#EFF3FB" />
        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
        <SortedAscendingCellStyle BackColor="#F5F7FB" />
        <SortedAscendingHeaderStyle BackColor="#6D95E1" />
        <SortedDescendingCellStyle BackColor="#E9EBEF" />
        <SortedDescendingHeaderStyle BackColor="#4870BE" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionStringx %>" ProviderName="<%$ ConnectionStrings:ConnectionStringx.ProviderName %>" SelectCommand="SELECT DISTINCT * FROM [Queryroutetag] WHERE ([tag] = ?) ORDER BY [id] DESC">
            <SelectParameters>
                <asp:QueryStringParameter Name="tag" QueryStringField="q" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
</asp:Content>
